IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[GetRefCodesByDomain]') AND objectproperty(id, N'IsProcedure') = 1)
	DROP PROCEDURE [dbo].[GetRefCodesByDomain]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/****** Object:  StoredProcedure [dbo].[GetRefCodesByDomain]    Script Date: 05/17/2006 11:40:00 ******/
CREATE PROCEDURE [dbo].[GetRefCodesByDomain] (
	@refDomain Varchar(50)
)
AS
BEGIN
	SET NOCOUNT ON
	
	SELECT RefDomain, RefCode, RefMeaning, Active
	FROM RefCode
	WHERE RefDomain = @refDomain

	
	SET NOCOUNT OFF
END
GO

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
